USING THE NEW FUNCTIONS IN APPLEWORKS V.3 SPREADSHEET
By Dave Stock
Copyright (c) 1990 Apple Users' Group, Sydney
Republished from Applecations, a publication of the Apple Users' Group, Sydney, Australia.
One day you decide to climb up on the roof to erect the latest log periodic antennae so you can get a really good picture on the T.V.
You decide it has to be high to be in line of sight with the local mast. Instead of doing it the easy way, by trial and error, why not work it all out using that new Appleworks V.3 spreadsheet?
The trig functions will tell you how much wire you need if you know the height of the antennae and the ideal angle for the guy wires.
Boot up the trusty old Apple (the family could never have managed without it). Enter the headings.
=========A========B========C========D========E========F=====
1| GUY WIRE ANTENNA GUY WIRE 3 4 BASE
2| ANGLE HEIGHT LENGTH LENGTHS LENGTHS DISTANCE
3|======================================================= 4| 40.0 10.0 15.6 46.7 62.2 11.9
Leave cells A4 and B4 blank for now, they're for fun later. Better still, enter @NA into them both. (Not available).
Into cell C4 type (B4/@SIN(@RAD(A4)))
Into D4 type (C4*3)
Into E4 type (C4*4)
Into cell F4 type (B4/@TAN(@RAD(A4)))
Notice the @RAD function which converts degrees into radians so the computer can handle it.
By experimenting with the angle and height, you, the master of trigonometry, can figure out the base anchoring distance for the guy wires and just how much wire you will need.
Warning! In your hurry to get back to the computer, do not fall from the roof.
Permission is hereby granted for non-profit user groups to republish this content. PLEASE CREDIT THE AUTHOR AND THE SOURCE: Applecations, publication of the Apple Users' Group, Sydney, Australia